﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Snipr.CoreLib.Data
{
    public class SqlManager
    {
        public int? ExecuteNonQuery(string sqlNonQuery) { return null; }
        public int? ExecuteNonQuery(string sqlNonQuery, List<object> parameterValues) { return null; }
        public int? ExecuteStoredProcedure(string storedProcedureName, Dictionary<string, object> parameterNamesAndValues = null) { return null; }
        public Dictionary<string, object> GetFirstRow(string sqlQuery, List<string> columnNames, string connectionString = null) 
        {
            string conn = ConnectionString.BaseConnectionString;
            Dictionary<string, object> columnNamesAndValues = new Dictionary<string, object>();
            DataTypeHandler.DBObjectToObject(default(object));
            return null; 
        }
        public Dictionary<string, object> GetFirstRow(string storedProcedureName, Dictionary<string, object> parameterNamesAndValues = null)
        {
            string conn = ConnectionString.BaseConnectionString;
            return null;
        }
    }
}
